Improving Performance in Integrated DSS with Object Oriented Modeling

The development cycle of a decision support system involves many resources, time and high cost and above all, the database schema used in the system is built only for some specific tasks. So, a relational database schema or a data warehouse prototype cannot be easily mapped and reused in multiple DSS projects. In this paper we propose an object-oriented (OO) approach and an OO database schema to accomplish the DSS implementation which require a multidimensional modeling at the conceptual level using fundamental concepts of OO (class, attribute, method, object, polymorphism, inheritance, hierarchy) to represent all multidimensional properties of a data warehouse, at both the structural and dynamic levels. Key-Words: Decision support systems (DSS), SQL optimization, integration, object-oriented modeling, objectoriented databases.